// sql语句
var sqlMap = {
    user: {
        // 添加用户
        add: 'insert into user(name, age) values (?, ?)', //?表示占位符
        //或 add: 'insert into user set ?',
        // 查询用户
        select: 'select * from user',
        select_name: 'select * from user where name=?',
        updatesql: 'update user set ? where name=?',//set为简易写法，1th?-新值,2th？-旧值
        deletesql: 'delete from user where name=?',
        softdeletesql: 'update user set status=? where name=?'

    }
}

/* select * from user where name like "%"?"%" 
    'select * from user where name=?'

*/
module.exports = sqlMap;